<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%><%@taglib
	uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><%@ page
	language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
	<!DOCTYPE html >
	<!--  Website template by freewebsitetemplates.com  -->
<html>

<head>
<title>Minimalistic Web Template</title>
<meta charset="iso-8859-1" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<!--[if IE 6]>
		<link href="css/ie6.css" rel="stylesheet" type="text/css" />
	<![endif]-->
<!--[if IE 7]>
        <link href="css/ie7.css" rel="stylesheet" type="text/css" />  
	<![endif]-->

</head>

<body>
	<div id="background">
		<div id="page">

			<div class="header">
				<div class="footer">
					<div class="body">

						<!-- include Menu -->
						<jsp:include page="Menu.jsp" flush="True">
							<jsp:param name="page_call" value="ShareWithMe" />
						</jsp:include>

						<sql:query dataSource="jdbc/sharewithme" var="rs">
						select bisbn, bnamethai, bnameeng, bwriter, bcountpage,
												bpublishing, bedition,btranslate, bprice 
												FROM  sharewithme.tbbooks
												where bisbn = ${param.bisbn }
						</sql:query>
						<table border="1" width="70%"  bgcolor="grey">
							
								<c:forEach items="${rs.rows }" var="book">
									<tr><th align="right">ภาพหน้าปก</th>
									<th align="left"><img width="150" height="200">${book.bpicname}</th></tr>
									<tr><th align="right">ISBN</th>
									<th align="left">${book.bisbn}</th></tr>
									<tr><th align="right">ชื่อภาษาไทย</th>
									<th align="left">${book.bnamethai }</th></tr>
									<tr><th align="right">ชื่อภาษาอังกฤษ</th>
									<th align="left">${book.bnameeng }</th></tr>
									<tr><th align="right">ชื่อผู้แต่ง</th>
									<th align="left">${book.bwriter }</th></tr>
									<tr><th align="right">ชื่อผู้แปล</th>
									<th align="left">${book.btranslate }</th></tr>
									<tr><th align="right">จำนวนหน้า</th>
									<th align="left">${book.bcountpage }</th></tr>
									<tr><th align="right">ราคา</th>
									<th align="left">${book.bprice }</th></tr>
									<tr><th align="right">จัดพิมพ์/จำหน่าย</th>
									<th align="left">${book.bpublishing }</th></tr>
									<tr><th align="right">พิมพ์ครั้งที่</th>
									<th align="left">${book.bedition }</th></tr>

								</c:forEach>
							</tr>
						</table>
					</div>
				</div>
				<div class="shadow">&nbsp;</div>
						</div>
				</div>
				<div class="shadow">&nbsp;</div>
			</div>
</body>
</html>